Dataset info
| Number of variables | 17 |
|---|---|
| Number of observations | 130990 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 17.0 MiB |
| Average record size in memory | 136.0 B |
Variables types
| Numeric | 16 |
|---|---|
| Categorical | 0 |
| Boolean | 1 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 0 |
| Unsupported | 0 |
Warnings
field1 has 8530 (6.5%) zeros | Zeros |
field2 has 61728 (47.1%) zeros | Zeros |
field5 has 66760 (51.0%) zeros | Zeros |
flag1 has 49549 (37.8%) zeros | Zeros |
flag2 has 47953 (36.6%) zeros | Zeros |
flag3 has 64958 (49.6%) zeros | Zeros |
flag4 has 125316 (95.7%) zeros | Zeros |
flag5 is highly skewed (γ1 = 27.08213937) | Skewed |
hour1 has 2403 (1.8%) zeros | Zeros |
indicator1 has 110307 (84.2%) zeros | Zeros |
indicator2 has 127715 (97.5%) zeros | Zeros |
amount
Numeric
| Distinct count | 37813 |
|---|---|
| Unique (%) | 28.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 26.2469796 |
|---|---|
| Minimum | 0 |
| Maximum | 95.4 |
| Zeros (%) | 0.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 10.385787 |
| Q1 | 12.95 |
| Median | 25.9 |
| Q3 | 38.85 |
| 95-th percentile | 49.95 |
| Maximum | 95.4 |
| Range | 95.4 |
| Interquartile range | 25.9 |
Descriptive statistics
| Standard deviation | 13.34643936 |
|---|---|
| Coef of variation | 0.5084942941 |
| Kurtosis | -0.954212051 |
| Mean | 26.2469796 |
| MAD | 12.12156772 |
| Skewness | 0.2834921994 |
| Sum | 3438091.858 |
| Variance | 178.1274437 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 12.95 | 35230 | 26.9% | |
| 38.85 | 33577 | 25.6% | |
| 49.95 | 5459 | 4.2% | |
| 10.36 | 5217 | 4.0% | |
| 25.9 | 4386 | 3.3% | |
| 31.08 | 2799 | 2.1% | |
| 11.01 | 1859 | 1.4% | |
| 20.72 | 807 | 0.6% | |
| 0 | 799 | 0.6% | |
| 59.4 | 607 | 0.5% | |
| Other values (37803) | 40250 | 30.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 799 | 0.6% | |
| 0.03534817076 | 1 | < 0.1% | |
| 0.03970638564 | 1 | < 0.1% | |
| 0.07332810688 | 1 | < 0.1% | |
| 0.113366467 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 95.4 | 32 | < 0.1% | |
| 95.3780835 | 1 | < 0.1% | |
| 92.81281327 | 1 | < 0.1% | |
| 91.43672948 | 1 | < 0.1% | |
| 91.10810633 | 1 | < 0.1% |
field1
Numeric
| Distinct count | 35613 |
|---|---|
| Unique (%) | 27.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 2.545214967 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros (%) | 6.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9765682554 |
|---|---|
| Coef of variation | 0.3836879274 |
| Kurtosis | 1.13491256 |
| Mean | 2.545214967 |
| MAD | 0.7546339418 |
| Skewness | -1.198454713 |
| Sum | 333397.7085 |
| Variance | 0.9536855575 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 3 | 56931 | 43.5% | |
| 2 | 21151 | 16.1% | |
| 0 | 8530 | 6.5% | |
| 4 | 7046 | 5.4% | |
| 1 | 1724 | 1.3% | |
| 2.679977303 | 1 | < 0.1% | |
| 0.5853961674 | 1 | < 0.1% | |
| 2.86489052 | 1 | < 0.1% | |
| 3.18329415 | 1 | < 0.1% | |
| 1.161912298 | 1 | < 0.1% | |
| Other values (35603) | 35603 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 8530 | 6.5% | |
| 0.000529498907 | 1 | < 0.1% | |
| 0.001371631148 | 1 | < 0.1% | |
| 0.001815627508 | 1 | < 0.1% | |
| 0.001819431741 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4 | 7046 | 5.4% | |
| 3.999935185 | 1 | < 0.1% | |
| 3.999808189 | 1 | < 0.1% | |
| 3.999710924 | 1 | < 0.1% | |
| 3.99970704 | 1 | < 0.1% |
field2
Numeric
| Distinct count | 26212 |
|---|---|
| Unique (%) | 20.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4296503904 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 47.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0.1479342966 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.4600681226 |
|---|---|
| Coef of variation | 1.070796473 |
| Kurtosis | -1.797746377 |
| Mean | 0.4296503904 |
| MAD | 0.441079641 |
| Skewness | 0.2806002015 |
| Sum | 56279.90464 |
| Variance | 0.2116626775 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 61728 | 47.1% | |
| 1 | 43052 | 32.9% | |
| 0.5227008025 | 1 | < 0.1% | |
| 0.9347192038 | 1 | < 0.1% | |
| 0.7883627878 | 1 | < 0.1% | |
| 0.5250309668 | 1 | < 0.1% | |
| 0.5439942994 | 1 | < 0.1% | |
| 0.08684193851 | 1 | < 0.1% | |
| 0.914669527 | 1 | < 0.1% | |
| 0.5496996104 | 1 | < 0.1% | |
| Other values (26202) | 26202 | 20.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 61728 | 47.1% | |
| 6.819387604e-06 | 1 | < 0.1% | |
| 2.047905146e-05 | 1 | < 0.1% | |
| 5.723877949e-05 | 1 | < 0.1% | |
| 0.0002544058877 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 43052 | 32.9% | |
| 0.999973497 | 1 | < 0.1% | |
| 0.9999251785 | 1 | < 0.1% | |
| 0.9999237458 | 1 | < 0.1% | |
| 0.9999040947 | 1 | < 0.1% |
field3
Numeric
| Distinct count | 67529 |
|---|---|
| Unique (%) | 51.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 625.8994177 |
|---|---|
| Minimum | -32265 |
| Maximum | 8193 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | -32265 |
|---|---|
| 5-th percentile | -6821 |
| Q1 | -1714.448253 |
| Median | 1442 |
| Q3 | 3556 |
| 95-th percentile | 5821.653438 |
| Maximum | 8193 |
| Range | 40458 |
| Interquartile range | 5270.448253 |
Descriptive statistics
| Standard deviation | 3995.516644 |
|---|---|
| Coef of variation | 6.383640136 |
| Kurtosis | 0.8884835266 |
| Mean | 625.8994177 |
| MAD | 3171.307683 |
| Skewness | -0.9113971825 |
| Sum | 81986564.73 |
| Variance | 15964153.25 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 3520 | 142 | 0.1% | |
| -3688 | 107 | 0.1% | |
| -5437 | 99 | 0.1% | |
| 2247 | 80 | 0.1% | |
| 1095 | 79 | 0.1% | |
| 4645 | 74 | 0.1% | |
| -342 | 72 | 0.1% | |
| 2191 | 69 | 0.1% | |
| 4654 | 68 | 0.1% | |
| 3382 | 65 | < 0.1% | |
| Other values (67519) | 130135 | 99.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -32265 | 1 | < 0.1% | |
| -30554 | 2 | < 0.1% | |
| -21927 | 1 | < 0.1% | |
| -21705 | 1 | < 0.1% | |
| -19525 | 2 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 8193 | 2 | < 0.1% | |
| 8177.061673 | 1 | < 0.1% | |
| 8152.983453 | 1 | < 0.1% | |
| 8148 | 1 | < 0.1% | |
| 8141 | 2 | < 0.1% |
field4
Numeric
| Distinct count | 49277 |
|---|---|
| Unique (%) | 37.6% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 13.53904837 |
|---|---|
| Minimum | 6 |
| Maximum | 46 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 6.456453732 |
| Q1 | 8.754712376 |
| Median | 11.46826219 |
| Q3 | 18 |
| 95-th percentile | 24 |
| Maximum | 46 |
| Range | 40 |
| Interquartile range | 9.245287624 |
Descriptive statistics
| Standard deviation | 5.99936456 |
|---|---|
| Coef of variation | 0.4431156754 |
| Kurtosis | -0.3492338706 |
| Mean | 13.53904837 |
| MAD | 5.175971414 |
| Skewness | 0.7285304326 |
| Sum | 1773479.945 |
| Variance | 35.99237512 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 9 | 11841 | 9.0% | |
| 8 | 9150 | 7.0% | |
| 7 | 7242 | 5.5% | |
| 10 | 5837 | 4.5% | |
| 6 | 5543 | 4.2% | |
| 18 | 3659 | 2.8% | |
| 20 | 3569 | 2.7% | |
| 11 | 3314 | 2.5% | |
| 21 | 3314 | 2.5% | |
| 19 | 3264 | 2.5% | |
| Other values (49267) | 74257 | 56.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 6 | 5543 | 4.2% | |
| 6.000495767 | 1 | < 0.1% | |
| 6.000779266 | 1 | < 0.1% | |
| 6.000908968 | 1 | < 0.1% | |
| 6.000996953 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 46 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 39 | 5 | < 0.1% |
field5
Numeric
| Distinct count | 32468 |
|---|---|
| Unique (%) | 24.8% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.444125239 |
|---|---|
| Minimum | 0 |
| Maximum | 26 |
| Zeros (%) | 51.0% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 2 |
| 95-th percentile | 7.246867784 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.312889772 |
|---|---|
| Coef of variation | 1.601585312 |
| Kurtosis | 6.163197737 |
| Mean | 1.444125239 |
| MAD | 1.691259955 |
| Skewness | 2.209647865 |
| Sum | 189165.9651 |
| Variance | 5.349459098 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 66760 | 51.0% | |
| 2 | 8445 | 6.4% | |
| 1 | 6481 | 4.9% | |
| 4 | 5857 | 4.5% | |
| 9 | 4590 | 3.5% | |
| 3 | 4351 | 3.3% | |
| 5 | 924 | 0.7% | |
| 6 | 721 | 0.6% | |
| 8 | 136 | 0.1% | |
| 7 | 136 | 0.1% | |
| Other values (32458) | 32589 | 24.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 66760 | 51.0% | |
| 6.481472272e-05 | 1 | < 0.1% | |
| 7.121091386e-05 | 1 | < 0.1% | |
| 0.0002287627294 | 1 | < 0.1% | |
| 0.000228955118 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 26 | 2 | < 0.1% | |
| 25 | 5 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 23 | 18 | < 0.1% | |
| 22.85921757 | 1 | < 0.1% |
flag1
Numeric
| Distinct count | 25811 |
|---|---|
| Unique (%) | 19.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5233306718 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 37.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0.6198913182 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.4653394223 |
|---|---|
| Coef of variation | 0.8891881318 |
| Kurtosis | -1.874060466 |
| Mean | 0.5233306718 |
| MAD | 0.4496269156 |
| Skewness | -0.09268535745 |
| Sum | 68551.08469 |
| Variance | 0.216540778 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 1 | 55632 | 42.5% | |
| 0 | 49549 | 37.8% | |
| 0.02250574734 | 1 | < 0.1% | |
| 0.1150619098 | 1 | < 0.1% | |
| 0.7118079229 | 1 | < 0.1% | |
| 0.2953365479 | 1 | < 0.1% | |
| 0.704285345 | 1 | < 0.1% | |
| 0.02139522028 | 1 | < 0.1% | |
| 0.5625276526 | 1 | < 0.1% | |
| 0.9962133067 | 1 | < 0.1% | |
| Other values (25801) | 25801 | 19.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 49549 | 37.8% | |
| 3.541714319e-05 | 1 | < 0.1% | |
| 5.669964827e-05 | 1 | < 0.1% | |
| 9.590530384e-05 | 1 | < 0.1% | |
| 0.0001652556536 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 55632 | 42.5% | |
| 0.9999237458 | 1 | < 0.1% | |
| 0.9998748683 | 1 | < 0.1% | |
| 0.999831513 | 1 | < 0.1% | |
| 0.9997455941 | 1 | < 0.1% |
flag2
Numeric
| Distinct count | 26551 |
|---|---|
| Unique (%) | 20.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.5331005047 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 36.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0.6637714371 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.4637815442 |
|---|---|
| Coef of variation | 0.869970184 |
| Kurtosis | -1.861314706 |
| Mean | 0.5331005047 |
| MAD | 0.4473225557 |
| Skewness | -0.1318877412 |
| Sum | 69830.83511 |
| Variance | 0.2150933207 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 1 | 56488 | 43.1% | |
| 0 | 47953 | 36.6% | |
| 0.9855023866 | 1 | < 0.1% | |
| 0.9322765772 | 1 | < 0.1% | |
| 0.2365479467 | 1 | < 0.1% | |
| 0.5402918206 | 1 | < 0.1% | |
| 0.5737556471 | 1 | < 0.1% | |
| 0.6937251094 | 1 | < 0.1% | |
| 0.9561584716 | 1 | < 0.1% | |
| 0.8537410573 | 1 | < 0.1% | |
| Other values (26541) | 26541 | 20.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 47953 | 36.6% | |
| 6.481472272e-05 | 1 | < 0.1% | |
| 7.755677949e-05 | 1 | < 0.1% | |
| 0.0001684870004 | 1 | < 0.1% | |
| 0.0002009639422 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 56488 | 43.1% | |
| 0.9999251785 | 1 | < 0.1% | |
| 0.9999237458 | 1 | < 0.1% | |
| 0.999900451 | 1 | < 0.1% | |
| 0.9998347443 | 1 | < 0.1% |
flag3
Numeric
| Distinct count | 25072 |
|---|---|
| Unique (%) | 19.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.4087591138 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 49.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0.02160590837 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.457891521 |
|---|---|
| Coef of variation | 1.120198928 |
| Kurtosis | -1.743483137 |
| Mean | 0.4087591138 |
| MAD | 0.4369993393 |
| Skewness | 0.3675678792 |
| Sum | 53543.35631 |
| Variance | 0.209664645 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 64958 | 49.6% | |
| 1 | 40962 | 31.3% | |
| 0.7610573589 | 1 | < 0.1% | |
| 0.3643844451 | 1 | < 0.1% | |
| 0.8521680523 | 1 | < 0.1% | |
| 0.5971017593 | 1 | < 0.1% | |
| 0.5003208709 | 1 | < 0.1% | |
| 0.542013834 | 1 | < 0.1% | |
| 0.1608025901 | 1 | < 0.1% | |
| 0.2581591639 | 1 | < 0.1% | |
| Other values (25062) | 25062 | 19.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 64958 | 49.6% | |
| 6.819387604e-06 | 1 | < 0.1% | |
| 2.650303699e-05 | 1 | < 0.1% | |
| 6.481472272e-05 | 1 | < 0.1% | |
| 7.121091386e-05 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 40962 | 31.3% | |
| 0.9999645829 | 1 | < 0.1% | |
| 0.9999237458 | 1 | < 0.1% | |
| 0.9999040947 | 1 | < 0.1% | |
| 0.999900451 | 1 | < 0.1% |
flag4
Numeric
| Distinct count | 3747 |
|---|---|
| Unique (%) | 2.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.02894620539 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 95.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.1526394126 |
|---|---|
| Coef of variation | 5.273209754 |
| Kurtosis | 29.98545865 |
| Mean | 0.02894620539 |
| MAD | 0.05540920351 |
| Skewness | 5.536512503 |
| Sum | 3791.663444 |
| Variance | 0.02329879028 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 125316 | 95.7% | |
| 1 | 1929 | 1.5% | |
| 0.6078718665 | 1 | < 0.1% | |
| 0.1430516384 | 1 | < 0.1% | |
| 0.139055534 | 1 | < 0.1% | |
| 0.9473627478 | 1 | < 0.1% | |
| 0.684314654 | 1 | < 0.1% | |
| 0.6085911745 | 1 | < 0.1% | |
| 0.8963961618 | 1 | < 0.1% | |
| 0.880772175 | 1 | < 0.1% | |
| Other values (3737) | 3737 | 2.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 125316 | 95.7% | |
| 0.0004529184404 | 1 | < 0.1% | |
| 0.0005417120821 | 1 | < 0.1% | |
| 0.0005756573698 | 1 | < 0.1% | |
| 0.0005884650903 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1929 | 1.5% | |
| 0.9999259819 | 1 | < 0.1% | |
| 0.999831513 | 1 | < 0.1% | |
| 0.9998210686 | 1 | < 0.1% | |
| 0.9995119598 | 1 | < 0.1% |
flag5
Numeric
| Distinct count | 20043 |
|---|---|
| Unique (%) | 15.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 5.534435074 |
|---|---|
| Minimum | 0 |
| Maximum | 3278 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1.472502526 |
| 95-th percentile | 2.611204682 |
| Maximum | 3278 |
| Range | 3278 |
| Interquartile range | 0.4725025259 |
Descriptive statistics
| Standard deviation | 91.92144098 |
|---|---|
| Coef of variation | 16.6090016 |
| Kurtosis | 820.1234694 |
| Mean | 5.534435074 |
| MAD | 8.394546592 |
| Skewness | 27.08213937 |
| Sum | 724955.6504 |
| Variance | 8449.551311 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 1 | 90552 | 69.1% | |
| 2 | 16212 | 12.4% | |
| 3 | 2547 | 1.9% | |
| 4 | 719 | 0.5% | |
| 5 | 181 | 0.1% | |
| 6 | 158 | 0.1% | |
| 7 | 148 | 0.1% | |
| 1600 | 85 | 0.1% | |
| 32 | 57 | < 0.1% | |
| 8 | 53 | < 0.1% | |
| Other values (20033) | 20278 | 15.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 12 | < 0.1% | |
| 0.1297001872 | 1 | < 0.1% | |
| 0.1818549865 | 1 | < 0.1% | |
| 0.1828350955 | 1 | < 0.1% | |
| 0.196032958 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 3278 | 49 | < 0.1% | |
| 3272.197437 | 1 | < 0.1% | |
| 3220.297905 | 1 | < 0.1% | |
| 3128.112757 | 1 | < 0.1% | |
| 3110.41653 | 1 | < 0.1% |
fraud
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 65495 | 50.0% | |
| 0 | 65495 | 50.0% |
hour1
Numeric
| Distinct count | 52653 |
|---|---|
| Unique (%) | 40.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 12.71214036 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros (%) | 1.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 9 |
| Median | 12.734323 |
| Q3 | 17 |
| 95-th percentile | 22 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 5.554090636 |
|---|---|
| Coef of variation | 0.4369123121 |
| Kurtosis | -0.4208584614 |
| Mean | 12.71214036 |
| MAD | 4.484500921 |
| Skewness | -0.2013979612 |
| Sum | 1665163.266 |
| Variance | 30.84792279 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 11 | 5592 | 4.3% | |
| 13 | 5447 | 4.2% | |
| 10 | 5412 | 4.1% | |
| 12 | 5381 | 4.1% | |
| 14 | 5249 | 4.0% | |
| 15 | 4890 | 3.7% | |
| 9 | 4697 | 3.6% | |
| 16 | 4551 | 3.5% | |
| 17 | 4174 | 3.2% | |
| 18 | 3863 | 2.9% | |
| Other values (52643) | 81734 | 62.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2403 | 1.8% | |
| 0.001095038451 | 1 | < 0.1% | |
| 0.001726082394 | 1 | < 0.1% | |
| 0.002359762227 | 1 | < 0.1% | |
| 0.004111678095 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23 | 2796 | 2.1% | |
| 22.99908003 | 1 | < 0.1% | |
| 22.99725726 | 1 | < 0.1% | |
| 22.99665323 | 1 | < 0.1% | |
| 22.99566175 | 1 | < 0.1% |
indicator1
Numeric
| Distinct count | 11070 |
|---|---|
| Unique (%) | 8.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.1154774459 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 84.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.2967496087 |
|---|---|
| Coef of variation | 2.569762489 |
| Kurtosis | 3.984768476 |
| Mean | 0.1154774459 |
| MAD | 0.1956089592 |
| Skewness | 2.385392001 |
| Sum | 15126.39064 |
| Variance | 0.08806033027 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 110307 | 84.2% | |
| 1 | 9615 | 7.3% | |
| 0.1751387605 | 1 | < 0.1% | |
| 0.2160052985 | 1 | < 0.1% | |
| 0.3306313711 | 1 | < 0.1% | |
| 0.1648389402 | 1 | < 0.1% | |
| 0.7871388925 | 1 | < 0.1% | |
| 0.3396646086 | 1 | < 0.1% | |
| 0.943727287 | 1 | < 0.1% | |
| 0.5133409241 | 1 | < 0.1% | |
| Other values (11060) | 11060 | 8.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 110307 | 84.2% | |
| 6.819387604e-06 | 1 | < 0.1% | |
| 0.0001118569663 | 1 | < 0.1% | |
| 0.0005756573698 | 1 | < 0.1% | |
| 0.0006064772471 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 9615 | 7.3% | |
| 0.9999259819 | 1 | < 0.1% | |
| 0.9999237458 | 1 | < 0.1% | |
| 0.9999040947 | 1 | < 0.1% | |
| 0.9997727581 | 1 | < 0.1% |
indicator2
Numeric
| Distinct count | 1805 |
|---|---|
| Unique (%) | 1.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.01795753515 |
|---|---|
| Minimum | 0 |
| Maximum | 1 |
| Zeros (%) | 97.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.12381508 |
|---|---|
| Coef of variation | 6.894881676 |
| Kurtosis | 51.54046363 |
| Mean | 0.01795753515 |
| MAD | 0.035021624 |
| Skewness | 7.206340716 |
| Sum | 2352.257529 |
| Variance | 0.01533017404 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 0 | 127715 | 97.5% | |
| 1 | 1472 | 1.1% | |
| 0.9645564031 | 1 | < 0.1% | |
| 0.5070820737 | 1 | < 0.1% | |
| 0.9504144424 | 1 | < 0.1% | |
| 0.2006013462 | 1 | < 0.1% | |
| 0.9835864867 | 1 | < 0.1% | |
| 0.4387854162 | 1 | < 0.1% | |
| 0.3780184767 | 1 | < 0.1% | |
| 0.1384065062 | 1 | < 0.1% | |
| Other values (1795) | 1795 | 1.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 127715 | 97.5% | |
| 6.481472272e-05 | 1 | < 0.1% | |
| 9.590530384e-05 | 1 | < 0.1% | |
| 0.0007174409417 | 1 | < 0.1% | |
| 0.001309489799 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1 | 1472 | 1.1% | |
| 0.9996570922 | 1 | < 0.1% | |
| 0.9994353596 | 1 | < 0.1% | |
| 0.9994231876 | 1 | < 0.1% | |
| 0.9993895199 | 1 | < 0.1% |
state1
Numeric
| Distinct count | 24982 |
|---|---|
| Unique (%) | 19.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 22.34705698 |
|---|---|
| Minimum | 0 |
| Maximum | 52 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5.622147032 |
| Q1 | 6.890175493 |
| Median | 19.21599413 |
| Q3 | 36 |
| 95-th percentile | 47 |
| Maximum | 52 |
| Range | 52 |
| Interquartile range | 29.10982451 |
Descriptive statistics
| Standard deviation | 14.95097957 |
|---|---|
| Coef of variation | 0.6690357297 |
| Kurtosis | -1.362946665 |
| Mean | 22.34705698 |
| MAD | 13.42099615 |
| Skewness | 0.3499677484 |
| Sum | 2927240.993 |
| Variance | 223.5317901 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 6 | 25475 | 19.4% | |
| 11 | 10931 | 8.3% | |
| 45 | 8470 | 6.5% | |
| 36 | 7079 | 5.4% | |
| 12 | 4718 | 3.6% | |
| 16 | 4216 | 3.2% | |
| 47 | 3990 | 3.0% | |
| 5 | 3949 | 3.0% | |
| 22 | 2776 | 2.1% | |
| 33 | 2491 | 1.9% | |
| Other values (24972) | 56895 | 43.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 341 | 0.3% | |
| 1.007897168 | 1 | < 0.1% | |
| 1.019972506 | 1 | < 0.1% | |
| 1.052146995 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 52 | 57 | < 0.1% | |
| 51.7094771 | 1 | < 0.1% | |
| 51.6066846 | 1 | < 0.1% | |
| 51.52498262 | 1 | < 0.1% | |
| 51.50679861 | 1 | < 0.1% |
zip1
Numeric
| Distinct count | 51493 |
|---|---|
| Unique (%) | 39.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 544.9570381 |
|---|---|
| Minimum | 2 |
| Maximum | 999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 80 |
| Q1 | 285 |
| Median | 531 |
| Q3 | 891 |
| 95-th percentile | 954.9984787 |
| Maximum | 999 |
| Range | 997 |
| Interquartile range | 606 |
Descriptive statistics
| Standard deviation | 314.0683271 |
|---|---|
| Coef of variation | 0.5763175903 |
| Kurtosis | -1.515343764 |
| Mean | 544.9570381 |
| MAD | 287.8267779 |
| Skewness | -0.02760517004 |
| Sum | 71383922.43 |
| Variance | 98638.91407 |
| Memory size | 1023.5 KiB |
| Value | Count | Frequency (%) | |
| 300 | 1571 | 1.2% | |
| 945 | 1459 | 1.1% | |
| 852 | 1154 | 0.9% | |
| 606 | 1053 | 0.8% | |
| 926 | 1048 | 0.8% | |
| 750 | 974 | 0.7% | |
| 900 | 944 | 0.7% | |
| 100 | 898 | 0.7% | |
| 921 | 848 | 0.6% | |
| 331 | 816 | 0.6% | |
| Other values (51483) | 120225 | 91.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 2 | < 0.1% | |
| 6 | 6 | < 0.1% | |
| 7 | 5 | < 0.1% | |
| 8 | 8 | < 0.1% | |
| 9 | 20 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999 | 5 | < 0.1% | |
| 998 | 24 | < 0.1% | |
| 997.1010331 | 1 | < 0.1% | |
| 997.0671007 | 1 | < 0.1% | |
| 997 | 42 | < 0.1% |
First rows
| amount | field1 | field2 | field3 | field4 | field5 | flag1 | flag2 | flag3 | flag4 | flag5 | fraud | hour1 | indicator1 | indicator2 | state1 | zip1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 38.85 | 3.0 | 0.0 | 1211.0 | 10.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 16.0 | 0.0 | 0.0 | 6.0 | 941.0 |
| 1 | 38.85 | 3.0 | 0.0 | -5078.0 | 21.0 | 1.0 | 0.0 | 1.0 | 1.0 | 0.0 | 1.0 | 0.0 | 13.0 | 0.0 | 0.0 | 16.0 | 602.0 |
| 2 | 12.95 | 3.0 | 0.0 | -2982.0 | 8.0 | 2.0 | 1.0 | 0.0 | 1.0 | 0.0 | 1.0 | 0.0 | 15.0 | 0.0 | 0.0 | 40.0 | 7.0 |
| 3 | 12.95 | 3.0 | 1.0 | -531.0 | 9.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 17.0 | 1.0 | 0.0 | 25.0 | 551.0 |
| 4 | 12.95 | 3.0 | 0.0 | 2128.0 | 8.0 | 2.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13.0 | 0.0 | 0.0 | 6.0 | 945.0 |
| 5 | 12.95 | 3.0 | 0.0 | 5440.0 | 8.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 13.0 | 0.0 | 0.0 | 21.0 | 22.0 |
| 6 | 12.95 | 3.0 | 1.0 | -6417.0 | 17.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 1.0 | 4.0 | 0.0 | 0.0 | 26.0 | 640.0 |
| 7 | 49.95 | 2.0 | 1.0 | 1211.0 | 25.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 10.0 | 0.0 | 0.0 | 19.0 | 402.0 |
| 8 | 38.85 | 3.0 | 1.0 | 1479.0 | 8.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 9.0 | 0.0 | 0.0 | 22.0 | 207.0 |
| 9 | 12.95 | 2.0 | 0.0 | -8812.0 | 9.0 | 9.0 | 1.0 | 0.0 | 0.0 | 0.0 | 2.0 | 0.0 | 9.0 | 0.0 | 0.0 | 11.0 | 321.0 |
Last rows
| amount | field1 | field2 | field3 | field4 | field5 | flag1 | flag2 | flag3 | flag4 | flag5 | fraud | hour1 | indicator1 | indicator2 | state1 | zip1 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 130980 | 11.433540 | 1.756518 | 0.585506 | 3882.828988 | 9.585506 | 6.072470 | 1.000000 | 0.585506 | 0.585506 | 0.414494 | 2.171012 | 1.0 | 15.973929 | 0.585506 | 0.0 | 39.539107 | 259.507292 |
| 130981 | 12.950000 | 3.637184 | 0.181408 | 2416.292414 | 10.000000 | 0.818592 | 1.000000 | 0.000000 | 1.000000 | 0.000000 | 1.818592 | 1.0 | 10.088448 | 0.000000 | 0.0 | 27.000000 | 393.274368 |
| 130982 | 11.736892 | 2.531618 | 0.468382 | 2256.962486 | 8.063237 | 0.936763 | 1.000000 | 1.000000 | 0.531618 | 0.000000 | 1.000000 | 1.0 | 11.442659 | 0.000000 | 0.0 | 15.620578 | 204.025723 |
| 130983 | 12.950000 | 3.331351 | 0.000000 | 2483.020813 | 13.337298 | 1.337298 | 1.000000 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.0 | 13.997027 | 0.000000 | 0.0 | 36.000000 | 117.000000 |
| 130984 | 23.966058 | 4.000000 | 0.000000 | -1493.000000 | 6.000000 | 0.000000 | 1.000000 | 0.000000 | 0.000000 | 0.000000 | 1.000000 | 1.0 | 18.805287 | 0.000000 | 0.0 | 24.000000 | 481.000000 |
| 130985 | 12.095563 | 3.657259 | 0.657259 | 3766.366884 | 11.084666 | 2.685481 | 1.000000 | 1.000000 | 0.342741 | 0.000000 | 1.000000 | 1.0 | 18.000000 | 0.000000 | 0.0 | 45.000000 | 787.088744 |
| 130986 | 41.136879 | 0.000000 | 0.000000 | -1740.904770 | 6.824100 | 0.206025 | 0.000000 | 0.206025 | 0.000000 | 0.000000 | 1.793975 | 1.0 | 6.648201 | 0.000000 | 0.0 | 26.678326 | 471.965021 |
| 130987 | 49.950000 | 2.951561 | 0.000000 | 1803.176537 | 8.000000 | 0.048439 | 0.000000 | 0.000000 | 0.048439 | 0.000000 | 1.000000 | 1.0 | 23.000000 | 0.951561 | 0.0 | 6.000000 | 921.242195 |
| 130988 | 27.319093 | 1.335626 | 0.000000 | -9980.067832 | 12.657495 | 0.445209 | 0.445209 | 0.445209 | 0.445209 | 0.000000 | 1.445209 | 1.0 | 10.219165 | 0.000000 | 0.0 | 6.445209 | 871.684532 |
| 130989 | 46.227794 | 0.670668 | 0.000000 | -6490.144036 | 9.000000 | 9.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 2.335334 | 1.0 | 14.024006 | 0.000000 | 0.0 | 36.000000 | 112.000000 |